package com.jeeplus.modules.sys.web;

import java.util.List;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.validation.ConstraintViolationException;

import org.apache.shiro.authz.annotation.Logical;
import org.apache.shiro.authz.annotation.RequiresPermissions;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.ModelAttribute;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.multipart.MultipartFile;
import org.springframework.web.servlet.mvc.support.RedirectAttributes;

import com.google.common.collect.Lists;
import com.jeeplus.common.utils.DateUtils;
import com.jeeplus.common.utils.MyBeanUtils;
import com.jeeplus.common.config.Global;
import com.jeeplus.common.persistence.Page;
import com.jeeplus.common.web.BaseController;
import com.jeeplus.common.utils.StringUtils;
import com.jeeplus.common.utils.excel.ExportExcel;
import com.jeeplus.common.utils.excel.ImportExcel;
import com.jeeplus.modules.action.entity.UserAction;
import com.jeeplus.modules.action.service.UserActionService;
import com.jeeplus.modules.kpi.entity.AchievementInfo;
import com.jeeplus.modules.sys.echartDto.EchartDto;
import com.jeeplus.modules.sys.echartDto.ResultProjectTypeDto;
import com.jeeplus.modules.sys.echartDto.ResultVo;
import com.jeeplus.modules.sys.entity.Result;
import com.jeeplus.modules.sys.service.ResultService;

/**
 * 成果登记Controller
 * @author lw
 * @version 2017-12-30
 */
@Controller
@RequestMapping(value = "${adminPath}/sys/result")
public class ResultController extends BaseController {

	@Autowired
	private ResultService resultService;
	
	@Autowired
	private UserActionService userActionService;
	
	@ModelAttribute
	public Result get(@RequestParam(required=false) String id) {
		Result entity = null;
		if (StringUtils.isNotBlank(id)){
			entity = resultService.get(id);
		}
		if (entity == null){
			entity = new Result();
		}
		return entity;
	}
	
	/**
	 * 成果详情列表页面
	 */
	@RequiresPermissions("sys:result:list")
	@RequestMapping(value = {"list", ""})
	public String list(Result result, HttpServletRequest request, HttpServletResponse response, Model model) {
		Page<Result> page = resultService.findPage(new Page<Result>(request, response), result); 
		model.addAttribute("page", page);
		return "modules/sys/resultList";
	}

	/**
	 * 查看，增加，编辑成果详情表单页面
	 */
	@RequiresPermissions(value={"sys:result:view","sys:result:add","sys:result:edit"},logical=Logical.OR)
	@RequestMapping(value = "form")
	public String form(Result result, Model model) {
		model.addAttribute("result", result);
		return "modules/sys/resultForm";
	}

	/**
	 * 保存登记成功
	 */
	@RequiresPermissions(value={"sys:result:add","sys:result:edit"},logical=Logical.OR)
	@RequestMapping(value = "save")
	public String save(Result result, Model model, RedirectAttributes redirectAttributes) throws Exception{
		if (!beanValidator(model, result)){
			return form(result, model);
		}
		if(!result.getIsNewRecord()){//编辑表单保存
			Result t = resultService.get(result.getId());//从数据库取出记录的值
			MyBeanUtils.copyBeanNotNull2Bean(result, t);//将编辑表单中的非NULL值覆盖数据库记录中的值
			resultService.save(t);//保存
		}else{//新增表单保存
			resultService.save(result);//保存
		}
		
		UserAction userAction = new UserAction();
		userAction.setAction("编辑成果");
		userActionService.save(userAction);
		
		addMessage(redirectAttributes, "保存成果详情成功");
		return "redirect:"+Global.getAdminPath()+"/sys/result/?repage";
	}
	
	/**
	 * 删除成果详情
	 */
	@RequiresPermissions("sys:result:del")
	@RequestMapping(value = "delete")
	public String delete(Result result, RedirectAttributes redirectAttributes) {
		resultService.delete(result);
		addMessage(redirectAttributes, "删除成果详情成功");
		return "redirect:"+Global.getAdminPath()+"/sys/result/?repage";
	}
	
	/**
	 * 批量删除成果详情
	 */
	@RequiresPermissions("sys:result:del")
	@RequestMapping(value = "deleteAll")
	public String deleteAll(String ids, RedirectAttributes redirectAttributes) {
		String idArray[] =ids.split(",");
		for(String id : idArray){
			resultService.delete(resultService.get(id));
		}
		addMessage(redirectAttributes, "删除成果详情成功");
		return "redirect:"+Global.getAdminPath()+"/sys/result/?repage";
	}
	
	/**
	 * 导出excel文件
	 */
	@RequiresPermissions("sys:result:export")
    @RequestMapping(value = "export", method=RequestMethod.POST)
    public String exportFile(Result result, HttpServletRequest request, HttpServletResponse response, RedirectAttributes redirectAttributes) {
		try {
            String fileName = "成果详情"+DateUtils.getDate("yyyyMMddHHmmss")+".xlsx";
            Page<Result> page = resultService.findPage(new Page<Result>(request, response, -1), result);
    		new ExportExcel("成果详情", Result.class).setDataList(page.getList()).write(response, fileName).dispose();
    		return null;
		} catch (Exception e) {
			addMessage(redirectAttributes, "导出成果详情记录失败！失败信息："+e.getMessage());
		}
		return "redirect:"+Global.getAdminPath()+"/sys/result/?repage";
    }

	/**
	 * 导入Excel数据

	 */
	@RequiresPermissions("sys:result:import")
    @RequestMapping(value = "import", method=RequestMethod.POST)
    public String importFile(MultipartFile file, RedirectAttributes redirectAttributes) {
		try {
			int successNum = 0;
			int failureNum = 0;
			StringBuilder failureMsg = new StringBuilder();
			ImportExcel ei = new ImportExcel(file, 1, 0);
			List<Result> list = ei.getDataList(Result.class);
			for (Result result : list){
				try{
					resultService.save(result);
					successNum++;
				}catch(ConstraintViolationException ex){
					failureNum++;
				}catch (Exception ex) {
					failureNum++;
				}
			}
			if (failureNum>0){
				failureMsg.insert(0, "，失败 "+failureNum+" 条成果详情记录。");
			}
			addMessage(redirectAttributes, "已成功导入 "+successNum+" 条成果详情记录"+failureMsg);
		} catch (Exception e) {
			addMessage(redirectAttributes, "导入成果详情失败！失败信息："+e.getMessage());
		}
		return "redirect:"+Global.getAdminPath()+"/sys/result/?repage";
    }
	
	/**
	 * 下载导入成果详情数据模板
	 */
	@RequiresPermissions("sys:result:import")
    @RequestMapping(value = "import/template")
    public String importFileTemplate(HttpServletResponse response, RedirectAttributes redirectAttributes) {
		try {
            String fileName = "成果详情数据导入模板.xlsx";
    		List<Result> list = Lists.newArrayList(); 
    		new ExportExcel("成果详情数据", Result.class, 1).setDataList(list).write(response, fileName).dispose();
    		return null;
		} catch (Exception e) {
			addMessage(redirectAttributes, "导入模板下载失败！失败信息："+e.getMessage());
		}
		return "redirect:"+Global.getAdminPath()+"/sys/result/?repage";
    }
	
	@RequestMapping(value = "page")
	@ResponseBody()
	public Page<Result>  page(String officeId, HttpServletRequest request, HttpServletResponse response, Model model,Result result) {
		   
			Page<Result> page = resultService.findPageByOfficeId(new Page<Result>(request, response),officeId,result);
		
		
		//addMessage(redirectAttributes, "删除成果详情成功");
		return page;
	}
	@RequestMapping(value = "count")
	@ResponseBody()
	public int  count(String officeId) {
		   
			int count = resultService.selectCountByOfficeId(officeId);
		
		
		//addMessage(redirectAttributes, "删除成果详情成功");
		return count;
	}
	//成果统计
	@RequestMapping(value = "resAmount")
	@ResponseBody()
	public	EchartDto  resAmount(String officeId) {
		EchartDto echartDto = resultService.findAmount(officeId);
		return echartDto;
	}
	@RequestMapping(value = {"content"})
	@ResponseBody
	public Result content(String id,Result result, Model model) {
		result.setIntro(org.apache.commons.lang3.StringEscapeUtils.unescapeHtml4(result.getIntro()));
		return result;
	}
	/**
	 * 项目类型 管理统计图
	 * @param result
	 * @param model
	 * @return
	 */
	@RequestMapping(value = {"echartProjectType"})
	@ResponseBody
	public List<ResultProjectTypeDto> echartProjectType(Result result, Model model) {
		List<ResultProjectTypeDto>  resultEchart = resultService.echartProjectType();
		return resultEchart;
	}
	
	/*@RequestMapping(value = {"score"})
	@ResponseBody
	public AchievementInfo resultRepub(ResultVo resultVo){
		resultVo.setProcessNode("3");
		AchievementInfo achievementInfo = resultService.selectResultRepub(resultVo);
		return achievementInfo;
	}*/
	
}